Forum Discussion
Solved
Representation of numbers in cell different to formula bar
Hi, I have an issue in a dataset where the values format in the cell is different from the value in the formula bar. Please see below: This is inconsistently present as an issue throughou...
- If some already have a point after the first number, then only Cell Format Custom
Enter: 0"."000
But if the existing point is not the first number, then probably only through VBA code.
Alfieb1996 Looks like a custom format in D2 and perhaps others, but not all.
If you want to have a decimal number (3 decimals I suppose) you need to enter it with the decimal point or us the Advanced setting under Editing options to "Automatically insert a decimal point, 3 places".
Hello,
Thanks for your response! Entering it isn't an option as I have many entries to change. I did try the Advanced setting but it didn't seem to alter how the number is represented in the formula bar unfortunately.
it's really frustrating as some numbers display correctly...thanks for your reply once again.
Thanks for your response! Entering it isn't an option as I have many entries to change. I did try the Advanced setting but it didn't seem to alter how the number is represented in the formula bar unfortunately.
it's really frustrating as some numbers display correctly...thanks for your reply once again.