Forum Discussion
Formatting Doesn't Work
NikolinoDE Thank you, I tried that and there was not a custom format. I changed it to General under that Custom Format tab and nothing changed. Interestingly enough, when I copied the column and pasted it into a new sheet, it automatically showed the Accounting format with dollar sign and decimal and such! But when I copied that same column with the correct formatting and pasted it back into the original sheet, all of the formatting was lost and it went back to just the single number.
For anyone else coming across this issue. I belive JeanBartz​ is actually in the 'show formulas' view. This view will display the raw text/value of any field. So formula details if there is a formula, or raw numerical values for any number.
Shortcut to get out of this is [ Ctrl ] +[ ` ] (That's a tilde, left of the 1 on US keyboards if you are looking for it.)
Or go to the formulas tab, and uncheck show formulas in the formula auditing section