View source: R/convert_to_excel_formula.R
convert_to_excel_formula | R Documentation |
Convert elements of a character vector to Excel formulas to preserve the character (string) format when opened in an Excel file.
convert_to_excel_formula(vector = NULL)
vector |
a character vector |
the output will be a character vector formatted as an Excel
formula. For example, if an element in the input vector was ".500"
,
this element will be converted to =".500"
, which will show up as
".500" in Excel, rather than as "0.5"
## Not run:
# compare the two csv files below
# example 1
dt <- data.table::data.table(a = ".500")
data.table::fwrite(dt, "example1.csv") # the csv will show "0.5"
# example 2
dt <- data.table::data.table(a = convert_to_excel_formula(".500"))
data.table::fwrite(dt, "example2.csv") # the csv will show ".500"
## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.