Hello,

I want to format a column of cells to prefix any number I type with 7000. I
tried the custom format of "7000"@ but I get the error checking triangle in
each cell telling me it's text rather than a number.
Is there something I can use in the custom formatting to achieve my goal
other than the "7000"@?

Thank you