•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to make Excel to stop seeing E as a scientific notation in a column
I need to display copy and paste valueues like 4E75, 5E77, 6E48 in a column. Excel keeps displaying them as 4.00E+75, 5.00E+77, 6.00E+48. How do you stop this behavior in Excel 2019? if anyone knows, greatly appreciated.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#Excel
#scientific notation
#column
#copy and paste
#display
#values
#4E75
#5E77
#6E48
#Excel 2019
#stop behavior
#4.00E+75
#5.00E+77
#6.00E+48
#formatting
#data entry